I have a table that is creating a record for each client that completes a form. I have another table on the same base which is a synced google drive table with all client folders. Is there a formula/automation I can use to link the "open in google dr...
Hi, we track which topics will be posted to social media mainly in calendar view in Airtable. Ex. Have "receipe" show up every Wednesday on the calendar instead of having to input the date manually. Any suggestion on how to accomplish that?
Hi! I'm having trouble with a formula where it brings back text and adds " " when it is done. Here is the layout:Column 1: Formula cell with the following formula {Client} & ' - ' & {Total Volume}Column 2: Linked to another table, displays {Client} n...
Hello,I need help with figuring out how to lookup the right price of an item for a particular customer from a table.I have an order line item table that contains "Customer Name" and "Item Name". Using this information together I want to look up the p...
Trying to create a condition via formula which will mean that a client won't be able to be quoted via airtable extension with the following:Formula:IF(Type="Client", IF({On Hold}="On Hold">"Good", " Good to Quote","On Hold - Do not Quote"))We are hop...
Hi everybody,if I can ask for help with formulas in IF statementsI have developed Glide app with Airtable, works really good.I have a table WorkOrders, and among other columns, I have:"Start time", "Start kilometers", "End Time", "End kilometers", "T...
How do I use sum values automatically calculated when grouping fields for other formulas?I have to calculate the sum of values of a grouped field in other formulas. Is it possible? someone told about rollup, but I did not manage to obtain any useful ...
Hi All I would like to know if someone can assist me with create the formula used in the time off id column for this video at the timestamp 2:04 https://www.youtube.com/watch?v=Q-MEmIHCHU4&t=8s
I have a simple task tracker with a single table containing a list of tasks. I have a self-linking field to allow for a single level of subtasks. I primarily use Interface lists to view tasks. However, I also assign tasks to be completed by varyin...
Okay guys, got a doozie... Basically, in the screenshot I have a table, which is the main table that 99% of things sprout off from. We have customers, who through a webflow form are able to select accessories to add on to their purchase. That gets re...
